Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

Frm56Msg

A message box with checkbox, 1 command button says ok only. Caller can set ...

Frm56Msg.zip

ToolPath

Returns the path of ThisWorkbook considering OneDrive Personal or Business ...

Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

CountArrayCol

Returns the count of array fields, given the dimension, using UBound ...

DB_ExtendedProperties

Returns extended properties of a database, knowing the ADODB connection

Files_MostRecentN

Gets most recent N files from a given folder. Uses Arrays, and the function ...

IsEven + IsOdd

Returns True if integer is even by using IsEven While IsOdd, will returns True ...